﻿<?xml version="1.0" encoding="UTF-8"?>
<form xmlns="http://www.evolutility.com" title="制定价格" icon="cube.gif" description="Customers">
  <data dbtable="MRP_CustomerProductPrice" splogin="asp.net membership" dbcolumnpk="ID" sppaging="EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @SQLpk, @pageid, @pagesize" />
  <panel label="产品列表" width="100">
    <field id="146" panelid="1" type="lov" typeid="5" label="客户名称" dbcolumn="CustomerID" dependency="ProductID" dbcolumnread="CompanyName" dbcolumnreadlov="CompanyName" dbtablelov="MRP_Customer" maxlength="2" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="146" panelid="1" type="lov" typeid="5" label="产品名称" dbcolumn="ProductID" dbcolumnread="Name" dbcolumnreadlov="Name" dbwherelov="MRP_MaterialMain.MType=5" dbtablelov="MRP_MaterialMain" maxlength="2" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="161" panelid="1" type="decimal" typeid="9" label="价格" dbcolumn="Price" dbcolumnread="Price" maxlength="8" readonly="0" required="1" optional="" fpos="30" search="" searchadv="1" searchlist="1" height="1" width="15" />
    <field id="38" panelid="1" type="lov" typeid="5" label="货币单位" dbcolumn="CurrencyType" dbcolumnread="DisplayText" defaultvalue="1"
       dbtablelov="View_Currency_List" dbcolumnreadlov="DisplayText" maxlength="0" readonly="0" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="0" height="1" width="10" />
    <field id="38" panelid="1" type="lov" typeid="5" label="税金" dbcolumn="Tax" dbcolumnread="TaxCustomeType" defaultvalue="1"
   dbtablelov="View_Tax_List" dbcolumnreadlov="TaxCustomeType" maxlength="0" readonly="0" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="0" height="1" width="10" />
    <field id="1167" panelid="1" type="date" typeid="5" label="价格生效日" format="{0:d}" defaultvalue="_tomorrow" dbcolumn="PriceStartDate" dbcolumnread="PriceStartDate" maxlength="10" readonly="0" required="1" optional="" fpos="90" search="" searchadv="1" searchlist="1" height="1" width="30" />
    <field id="1168" panelid="1" type="date" typeid="5" label="价格失效日" format="{0:d}" defaultvalue="2099-12-31" dbcolumn="PriceEndDate" dbcolumnread="PriceEndDate" maxlength="10" readonly="1" required="1" optional="" fpos="90" search="" searchadv="1" searchlist="1" height="1" width="30" />
  </panel>
</form>
